SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537804 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537804 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560838,259337,909200,302954,405506,725230,229252,817479,795054,960110,858152,865677,971809,677889,760156,814973,756090,640175,379227,1042806,867680,897384,366489,301014,407631,568732,356121,340534,301673,268041,303102,770479,986059,661033,733364,777928,291599,1005714,298559,474819,761883,50260,448987,631758,631299,40287,378000,735934,833837,325523,143715,318966,1001658,667935,51077,797360,1008507,1013176,659946,771392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]