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` = 206433 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206433 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324080,180585,141748,521479,209120,962628,94663,552995,18940,817532,204629,747187,204332,211364,501403,385730,31379,852113,9997,578223,1047875,384342,423987,949824,303168,348406,525834,606499,866571,702683,974158,978601,598787,252340,247005,192702,463252,473809,949932,855327,810439,652733,753102,571258,235218,400887,415753,1017419,562718,705087,932285,178166,537828,91151,712212,834396,340156,631276,994726,95573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]