SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410798 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410798 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596642,100048,485768,257673,235783,616461,306210,86021,778357,870249,664306,1002032,570248,658015,552175,118536,450049,682848,363662,99781,202721,236792,113770,890968,288263,566654,283185,42804,138338,833528,1008486,11748,935727,185242,127738,76462,489516,35282,943336,340640,323088,330157,136226,287948,680617,510792,776192,807250,39871,110146,22711,793216,169757,560484,1048670,741956,592236,63051,269734,873329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]