SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40524 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40524 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372333,358483,165591,803693,562938,23366,1010788,715982,766053,471892,755345,420370,561792,141423,145630,835228,156143,790573,113080,186434,274632,684677,664551,498673,816025,49577,22895,860972,22080,335416,657805,339888,577788,827116,538972,192252,752412,921478,150745,6050,1037242,162943,631414,560209,499788,496391,185783,898688,569443,42906,15130,647473,388536,414750,694110,630229,541207,976325,983105,469514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001769s ]