SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558938 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558938 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031407,245839,1046350,203379,456102,181952,636556,833558,897470,961732,973792,214892,710012,387373,967860,558634,462521,777507,207587,502396,368348,528844,859180,1048266,906995,692559,448440,56179,305337,712987,369374,612553,35962,903776,267630,410261,601736,577506,703419,81369,1025265,808291,962264,505573,494162,69026,76912,543867,277549,463958,320995,414050,816871,597729,189258,446315,426204,848644,296538,774950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]