SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591899 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591899 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815776,81037,967205,584538,467293,679838,559399,348410,588,472146,448682,489874,860526,648661,109340,491774,313487,232878,518837,275764,354861,1038976,722541,9275,655228,885811,434688,40857,827070,670712,78315,741775,985610,289561,73108,394559,324282,987952,611263,147838,267339,49859,906475,262990,73426,288613,843091,625387,189036,292916,352467,711144,494039,778835,784963,124039,549091,174998,54673,57778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]