SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44518 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44518 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145740,769494,191357,61362,176354,960804,957959,185421,356771,483870,204458,398398,74023,1047878,695115,872174,678131,200857,769904,800591,11415,581233,99042,532452,247013,86373,576420,424671,816501,995573,505014,50391,170322,862447,456137,528341,947733,164457,440689,603972,869976,470475,978772,597030,824322,394092,181181,834490,287560,745542,164852,799464,877020,420377,341297,538646,460088,401029,695232,486821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]