SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031180 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031180 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869163,91089,95118,918603,813244,936051,701204,343074,345388,720270,335923,993038,493244,774636,433804,332375,301840,140522,1010225,378722,677992,665321,520569,128565,785763,773525,422870,451992,799381,740174,392603,956487,444966,453105,944674,113758,762377,363918,215410,96223,131626,704677,1020139,113981,892949,594116,813697,244468,543974,847212,156221,507090,683329,1017894,259746,153305,1027321,712865,649205,834201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]