SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501851 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501851 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451571,662813,705217,747984,13909,746367,897295,618695,37299,60040,922094,563605,467607,960860,54344,700370,235577,885886,1015979,709281,781730,898425,628652,968546,383809,235797,332798,250114,948743,75191,719356,650980,483007,450645,708537,831685,853160,800614,284132,46016,86196,935342,813202,108737,1017605,662433,411920,532495,509061,303347,448186,917235,471978,102683,715580,520770,1024867,523435,571494,722589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]