SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111504 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111504 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308508,345962,1009811,385259,744377,261576,599877,952051,10045,573362,36468,944097,128955,1002852,2252,1018352,292971,394537,697510,1036943,257171,880996,262529,880500,771770,241944,51904,131601,1008545,331103,180596,48782,956479,509282,504932,851728,278440,326788,857143,116689,462143,599884,593030,865577,768606,716684,450471,438830,139068,740623,181802,861091,245163,574986,257742,192790,530180,88372,849303,998776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]