SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54115 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54115 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206378,248069,514968,438449,382423,541159,509173,342022,774385,108091,742055,625501,904903,14862,135181,909895,774291,894289,734134,643486,386308,140341,265278,900245,298571,1025365,450566,678994,135822,210678,421371,324673,290061,896033,270874,801261,536458,531237,340905,408016,987249,917438,873480,741442,715660,245769,478483,604525,832851,997034,223714,483146,566361,181896,616866,63747,867065,315773,642546,777283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001126s ]