SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55014 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55014 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244604,896173,33114,727549,467711,495950,412322,793661,258516,678398,899306,709441,1038960,998005,559133,1006819,251637,525272,890085,116298,336746,677945,893864,694898,777765,359933,304701,938651,139065,961457,1026217,81522,725827,755816,600286,247298,957636,624308,49334,505121,796444,542392,423427,429533,92647,790701,1027599,145986,66239,392933,531812,582335,651557,495360,652043,61051,75460,249519,521981,576379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]