SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475043 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475043 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841770,74812,487740,665196,265160,1038620,318484,381441,47397,484615,842159,101215,696313,202866,555990,4732,705588,551106,218203,301368,80215,897120,533777,644855,781469,319468,714293,160299,1030038,637754,201932,577594,88320,931901,840024,671673,100635,641674,488321,849013,86037,243119,847920,334031,937247,541250,1046701,262889,535554,140510,399649,950363,889253,195344,716448,738227,856138,110027,177418,655220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]