SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476315 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476315 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392011,873366,173174,52857,494399,444195,682413,749652,704625,1004057,791632,999648,1012046,716346,224996,571166,500672,649748,671037,193345,665737,711825,808843,96545,267428,788967,686907,70423,656031,117246,417725,182819,911719,983264,701828,875879,1022478,139606,99017,362034,664700,175361,492482,233466,249407,88824,620461,77502,253646,811199,829356,490440,125979,75115,890488,552803,679032,194985,821888,878776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]