SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 784628 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 784628 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522036,825067,1019484,722252,863012,535060,19882,696750,493710,199929,582042,774244,700119,14608,708550,959122,279703,411122,897005,354703,174698,119974,50792,614140,835136,567126,747608,59352,11053,386617,820693,290778,987908,1016300,560026,1033657,978653,114862,829012,905484,472844,399458,581771,567237,440984,708987,208763,100386,578230,861912,697457,757363,884085,837550,655670,372400,100736,273585,103283,444228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 784628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 784628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]