SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534206 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534206 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368770,649350,409465,517166,546798,287988,256710,907217,551853,978520,943469,235740,866612,174259,210304,621713,506343,972036,143067,162743,1030455,624253,961023,149988,439292,520197,32274,789174,601844,1021777,367465,203513,931216,569505,721604,761774,784324,558974,400891,591602,884993,338358,588404,830042,896083,46593,1008100,754871,877234,137757,544026,635041,210106,441562,316118,964208,152602,1030784,599163,642971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]