SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842008 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842008 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528021,702522,737955,812743,761044,166201,289597,284623,1043059,366110,441949,236683,254489,884982,83972,311752,49794,658732,185006,590386,69149,451710,542726,34656,449409,690310,981136,721303,219270,487832,943368,927481,610390,932033,75551,246420,833956,245539,240899,959981,920236,460555,311249,792664,649489,849816,86408,921071,247318,898801,288117,997254,9017,546321,220432,614380,499518,507049,481397,417518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]