SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423380 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423380 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904516,270691,208944,35613,177852,586247,241563,338392,608552,1006533,769964,406443,102113,178292,361782,1674,556977,571108,791116,853920,70863,166204,743556,820522,563829,715528,644454,207512,832100,848078,351025,473463,467792,972742,593519,858701,324748,127883,319506,109446,234415,208594,329626,399457,967769,662823,65817,76511,364523,85733,396716,19903,465774,311338,886660,643698,1010985,677422,113491,227422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]