SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285656 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285656 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371672,156024,92005,414689,162080,44917,508835,3069,280413,199037,845269,499798,772683,883470,1000009,666253,811363,883152,678821,837513,83366,63808,626234,678101,511004,156474,962461,481074,825312,907708,127341,141327,676723,834127,492647,700033,296952,677539,450210,153333,943219,40304,772787,517912,408696,612917,763423,502968,6283,272803,298554,810015,795754,160,976488,893585,908610,443100,402270,361315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]