SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368714 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368714 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033797,375795,1032403,216856,275524,519131,137308,561803,589677,415900,209997,1035167,759054,649472,386031,968346,882179,531953,224270,1009103,348962,867294,556026,322988,691362,194902,800170,510697,69051,241325,568110,450362,477450,168581,771220,895969,501995,46301,84976,383785,602977,719595,927593,11783,496060,595272,382576,865419,40631,399247,728833,375053,16875,751371,1021700,301928,971818,765647,813643,664510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]