SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316712 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316712 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263818,987807,1024948,378298,512756,1008314,202004,141614,561567,438361,949074,116107,953221,1016923,441985,251512,75534,518865,532904,319365,279047,180925,160693,1031814,421881,569944,1039918,435800,682541,290115,10418,763858,917301,975092,980285,867939,1011455,412928,1047750,375987,357210,230780,896851,450769,339947,431084,1042178,184080,276615,58054,869778,215639,270673,405812,905443,887719,559687,615430,172993,753208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]