SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525240 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525240 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187918,572652,796154,729020,1011383,435175,487934,879354,455508,303377,419854,790940,595986,939832,970857,677208,766423,1013180,855990,917411,662689,482674,941535,913507,932511,269144,467866,211734,754805,863155,202325,287184,428604,575552,94535,916200,783492,761591,784548,149351,523028,631805,626636,619809,117688,45679,914593,878075,559882,697105,203131,19944,909434,613400,308135,221513,284704,118076,760989,652393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]