SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343240 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343240 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438857,697459,375031,166294,473176,403935,351323,789431,68771,760450,676338,371274,966369,1048769,1010489,296788,592183,1030075,1029778,911196,608382,447574,574654,24034,940245,671146,463758,649621,500982,581784,151719,907150,973060,388395,970642,852338,288935,25386,603045,813700,532293,596169,835516,854399,79396,501257,694440,920229,197663,242179,241412,667583,965153,194647,579598,99088,751366,704431,341815,905417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]