SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511234 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511234 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585845,351152,432923,779118,713472,510224,562090,694592,757496,245706,645366,1006917,238974,71345,966290,254116,864988,314896,302165,201593,423159,399771,505078,803689,540825,1035054,633243,1016585,505096,516499,213908,226800,976658,1002239,183576,475438,1004891,678887,1017037,14675,962302,618689,688576,102455,427412,1005141,302497,165682,897095,1001213,972471,29101,617629,979277,465255,489311,897487,398922,871662,175308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]