SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391211 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391211 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654454,556824,247532,76201,967059,928798,357698,894871,831207,779758,922839,710920,370130,252399,222172,799847,277735,173702,937482,760773,908989,765599,922390,156521,686421,509132,188294,401624,801760,584084,129880,349648,1009451,696549,104815,579685,935512,512674,405790,352858,180253,732972,818162,570025,358461,414880,217974,80372,848063,603528,704749,507092,333873,151946,119666,765289,958896,1024879,490526,685131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]