SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035212 LIMIT 1 [ RunTime:0.000908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035212 [ RunTime:0.004611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102164,406981,531896,241995,1032748,1012177,745262,115989,761135,466800,247724,323201,1048547,516636,670377,252315,120136,364809,560279,750672,677801,670560,1002019,197430,976312,158890,706747,724679,338454,811604,137342,713690,286760,632668,406075,839000,172973,355012,580303,777680,678850,484952,326273,784054,988870,268698,871346,34874,848467,612566,603722,823408,361483,514784,158761,78889,147175,322773,659318,968490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002073s ]