SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193580 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193580 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529298,988082,926295,245926,460368,993637,515312,214420,470265,691548,961132,607993,977002,339959,288250,109049,828942,82972,781208,34285,803649,80179,302217,186983,783480,345880,621960,715427,341200,666768,997665,817653,896789,387947,814462,492071,642304,330124,365047,5645,608334,797170,940415,983931,275634,714614,607763,832140,854386,889477,351075,860780,430965,451689,957330,687759,820524,6504,898089,292750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]