SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40398 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40398 [ RunTime:0.001319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475993,297498,597857,75588,1040629,504926,405564,2534,188584,993932,197182,1037684,653534,582039,567997,943228,53582,549360,208367,92982,476622,233059,224552,523672,955399,649924,92303,600782,955219,199768,657055,12213,733534,10361,811339,647712,703152,356183,164916,464037,1009304,973063,659179,893662,856600,494701,303027,917827,52134,675697,711958,763382,677557,964358,194212,75078,372931,102021,577075,1030685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]