SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503856 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503856 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695804,549881,663813,222005,892896,578702,199623,30111,245563,480081,846512,819190,1006636,841053,172744,856061,404490,686475,1018087,279154,610917,627736,34372,275311,195988,529443,82739,1019660,778700,470269,171953,868623,1003015,441038,316490,848154,300746,757418,1021737,719847,1033895,68036,695823,686146,428850,454732,506666,180686,776480,1005673,496968,472793,1046605,735848,904549,755151,224231,371345,407493,350671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001839s ]