SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553912 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553912 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902924,927808,206764,752463,215115,487701,513002,916426,988297,811914,821642,648161,993960,412423,726001,581655,560653,242901,889563,380641,125183,85867,237691,381193,752369,536833,557517,305208,814826,818651,545820,649358,958957,575673,80674,34131,930364,499977,235204,656743,74102,972410,103997,132729,944213,689512,707751,908425,515145,37369,249920,927778,337234,364007,786252,720134,716722,368489,499041,22852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]