SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422581 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422581 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942219,914614,55624,944842,394082,988276,418592,1026146,77131,292861,287573,277024,754650,89002,545432,953864,233392,966929,850210,569860,387021,137080,451786,89913,557915,159857,185903,6304,845491,684654,678524,316062,494606,908007,385941,720758,836542,852947,208316,567678,151872,585691,200154,571242,125670,526635,64957,682449,316012,250116,871251,224809,727645,364160,855264,728579,939509,508660,536465,239814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]