SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80380 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80380 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815219,541906,237094,1015586,562107,295767,205733,974059,432461,104668,633471,1008029,168058,803585,390518,802682,320449,752513,110867,21690,103322,584931,303401,827089,321447,388180,853176,603577,869322,863036,119167,419573,483057,541777,258402,149198,850563,252468,207171,695840,139308,118676,518755,476665,917926,1022260,339500,88398,30925,987624,478205,672909,19243,621897,534739,846885,430572,674448,1010832,1018994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]