SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429896 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429896 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246068,344628,508463,261729,582618,375993,994500,49599,288090,159211,140391,553401,466480,41202,200604,822586,208281,835137,320651,668454,692993,713396,857167,389602,120056,587889,670898,59302,611258,539674,716226,893813,465121,1046892,434777,42813,302463,465278,131639,1015732,181337,460275,70091,55970,84325,716219,635833,737767,681254,964851,864008,350114,25739,151736,709159,572505,273022,606845,209196,62691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]