SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410098 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410098 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96629,714250,42585,2743,664257,48536,1010878,514574,562258,588086,388001,1044083,247918,1039672,648672,515539,219534,827900,993538,650824,132599,44724,332889,260176,562599,755725,442199,674360,117478,112092,997703,130370,879195,74040,60270,1038775,341410,272209,508110,392550,450619,150242,747278,682544,1039108,401673,2616,91750,886422,924464,483372,632546,39712,191940,769459,130810,247770,806750,731802,887474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]