SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437623 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437623 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008899,220648,908000,614026,310396,180832,671253,876161,673617,206318,956671,97071,628243,68466,952954,643112,304615,725260,609374,849730,63885,191042,813155,15264,968542,20260,393358,143893,625936,654445,869626,176239,972098,974605,137035,997448,218351,294585,893341,1011204,99633,587119,98999,814090,572594,628302,84520,867956,572807,1001352,109302,284184,127439,16800,849589,231423,390707,190372,903040,726045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]