SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354158 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354158 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470876,358983,531452,197376,887360,23917,138717,729088,339648,456345,481301,172374,314091,888054,694309,454406,958730,480659,201291,530212,902177,548465,782750,981203,472419,434186,70243,891693,423776,553060,1016761,350130,444636,499694,983664,413169,800278,29644,381713,17950,732075,154394,379105,775327,859276,811566,755998,943865,609640,47919,343294,117795,501255,399967,81270,173504,65835,311092,652999,78388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]