SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506399 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506399 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144276,587780,181831,703090,962172,52883,998143,517087,779334,305254,501524,829528,702051,126264,691257,219330,249306,322371,700541,878243,78849,313556,1021763,857824,395604,844554,849928,814371,65782,415181,679652,214679,941166,543108,749131,459171,330129,736751,258745,1029659,776226,999168,921059,430420,730865,1008334,448011,332625,88168,653583,945288,787803,422562,627807,870601,677433,694612,692641,709289,713956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]