SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 226210 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 226210 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430535,950775,1010972,412778,262056,1030247,1040997,246114,681600,1007239,1031738,265426,1019510,187722,896741,80978,561709,741552,264329,417795,264614,122910,757181,180459,229497,168496,432845,202737,745784,555950,659769,520701,150643,233481,587961,1033914,632373,161137,888653,576452,882570,35169,106079,1000709,187951,25076,211263,956292,699844,555764,975111,104857,330555,515982,119016,524954,987297,207100,462923,151171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 226210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 226210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]