SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514909 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514909 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631309,384309,424672,851246,411045,49984,337693,180071,189776,264840,62829,944454,38756,361634,776077,239470,360626,421983,458498,701393,997204,872520,642092,155046,615869,686809,156880,587049,296289,1044324,680610,872298,379422,796948,560905,46085,258476,464259,819721,878492,346306,571534,792303,118592,3034,996880,929740,768176,786005,160621,298675,887861,1047643,324787,539990,75936,488036,119579,566024,509749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]