SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403699 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403699 [ RunTime:0.003707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829231,405270,798452,394228,495676,765333,368931,236060,544192,316599,200479,433777,687951,915282,418829,269953,401461,679713,311791,983126,293371,385435,576492,431707,166918,241701,195544,948507,780880,265753,449083,897071,828584,432110,888671,318699,91568,562994,543179,742702,63872,1034053,927611,269042,994759,57026,570667,671568,666345,690747,629155,263687,689018,600685,345862,321393,967908,663427,717527,1010026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]