SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196196 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196196 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418400,614021,587109,200833,349331,840334,122967,544651,681023,59660,537894,137614,513745,620148,266023,642620,294198,1032532,378687,481534,198628,7195,1020643,565631,267994,413215,711914,274611,717276,249790,380403,584935,778625,182378,208751,398604,937191,952267,126082,336135,974345,96394,1041095,131976,832722,547626,251105,204796,432876,918719,44454,249345,205557,505379,831622,8599,716956,281592,940559,130287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]