SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841069 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841069 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922017,5922,919998,478438,1048545,151100,839165,885683,1907,855040,123186,189040,659751,160461,287148,372544,225085,637049,567822,872783,903517,470576,132138,620116,231428,431279,237955,931509,771868,563419,504311,44951,244158,93452,844187,377762,1016700,25934,526568,783398,432944,522934,226824,271568,672518,695822,102814,112766,795826,380528,590095,158455,205026,107642,533475,400236,684390,585414,112800,695604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]