SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53501 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53501 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626081,471534,712490,670515,928180,559137,160641,379190,256222,371663,422359,907926,1010248,701548,748825,691713,635991,812118,577656,715643,108455,796631,151936,697294,1048558,518091,283328,867920,693451,431633,424028,756370,495158,158995,894344,953910,143920,544442,47025,727263,146020,60808,562645,902349,720356,869193,179772,780342,169387,513072,765369,476980,53305,596813,598168,819158,762093,526696,529011,415791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]