SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567299 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567299 [ RunTime:0.001426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739985,428823,606823,393897,539711,987200,81240,694187,14914,994720,798750,394912,19968,657319,982228,675596,910911,525893,1006901,1029989,521043,297910,990739,651564,563652,600358,526236,153826,323513,225901,977159,829467,828115,191442,84983,664232,349590,457559,633322,729326,803711,458675,225819,995579,498220,4925,152805,413411,568144,163613,879917,818958,181830,447466,588378,317317,744994,593662,550315,517226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]