SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443499 LIMIT 1 [ RunTime:0.000717s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443499 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588000,655338,625802,1009960,772350,873807,752117,366947,197822,756219,496621,683673,961092,920125,384707,872924,720731,245738,836772,1005962,532583,779159,657673,62504,77671,858744,694319,463710,542881,262389,875444,236079,204620,67365,1002705,985678,1001023,1015863,1018588,537160,991316,831759,473984,645301,346508,487104,428131,509751,279484,1010218,85446,539755,6497,600704,29722,42773,324611,462306,266686,275136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]