SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393201 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393201 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333775,769297,321188,456521,663714,718350,171279,976174,577433,611908,513259,968412,493747,342481,561662,642573,183241,585913,440534,788507,407923,502357,736309,429025,669724,477595,232828,992188,168190,1031448,934402,689069,959041,233910,548073,354155,201237,735887,758983,592890,790663,1032808,499103,88577,377360,212022,977006,598296,44882,18870,567429,329843,608181,1028634,259231,475766,808073,352246,64519,1011034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]