SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340082 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340082 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522968,76828,415482,222693,988048,267177,616257,68628,116553,946820,506958,46927,303631,505084,1003759,1017549,1015924,939196,154667,392361,40319,884378,321399,636867,63510,616275,408611,760191,974390,952326,47521,877,786684,803941,739664,787131,377791,520435,506999,809015,955378,635452,644542,394159,1038413,16843,452165,737694,460369,231924,907574,295017,764554,696478,709604,183995,4520,53540,199118,79367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001534s ]