SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022275 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022275 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042657,448140,850555,457197,352989,720115,607120,839999,571445,137746,674147,604363,531532,473504,139482,447158,625971,578586,85617,737332,218619,837723,124438,492010,646071,192847,187165,504862,40487,951539,168564,339917,933781,217411,213636,99495,937932,562808,718448,1021652,730004,180068,307566,457969,1022035,692545,630355,956075,688944,167844,566894,487629,371387,104693,393643,114377,149103,264267,433823,187274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]