SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411685 LIMIT 1 [ RunTime:0.000834s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411685 [ RunTime:0.006624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282770,390374,585568,735129,442618,537499,19628,919250,1008448,538515,43569,964457,961601,125165,153604,673380,836109,296857,27991,619138,214712,346414,923553,571540,891098,852834,452716,174553,111723,999160,683599,168517,972928,814357,868387,884509,440405,336248,783521,675739,353557,1039859,800733,666509,387410,736956,565349,72107,224344,57877,79866,861534,243906,477557,945376,461021,52277,759238,1045654,25742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]