SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397050 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397050 [ RunTime:0.003854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423830,812108,1039294,892498,422593,1047616,584528,93803,502395,563481,841110,982831,831344,493960,604683,304855,1033497,17102,756961,501884,971100,545749,355297,1039040,382833,906710,850071,178337,731316,1046414,685203,916991,387563,356364,282185,223310,1035527,683370,270887,423355,858492,303904,101549,948019,650364,602341,138095,671069,182560,398625,589874,425424,895209,421285,812389,682742,843118,284125,340570,545232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]