SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301215 LIMIT 1 [ RunTime:0.003568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301215 [ RunTime:0.003975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023502,1002850,125099,898237,580552,92753,263534,508504,439532,54408,879482,473349,325052,673574,609549,367611,186257,770375,518648,171768,859979,407840,116872,121523,840026,14010,970451,902840,533813,381313,215464,65970,320615,619189,367069,809156,65770,103213,262280,1020535,508741,411487,853978,862866,180863,557497,36402,168931,961812,1045535,233803,834815,520388,631288,910123,530850,35144,951885,974571,721296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002971s ]