SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539028 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539028 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899435,489533,228934,748703,938705,710592,793779,145836,735817,453057,733677,924731,280934,460562,722745,1026677,356477,906174,346590,460749,485675,990757,41370,858677,602301,997389,772357,960788,326351,933569,721608,708747,222011,222735,620766,60573,845204,276976,316653,342664,20717,197566,614237,509796,464242,123352,754788,321290,52536,744707,744004,367686,692564,360463,883294,115541,970392,87831,219138,700668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]