SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 923790 LIMIT 1 [ RunTime:0.002489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 923790 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486819,367808,26673,795136,1015835,97509,115703,141120,531114,466902,49319,711817,190572,353510,125551,207048,686315,1034750,836605,686820,908576,243854,414367,990688,552225,1042481,1037784,478430,369067,633127,129544,297117,431726,293617,297405,271693,54535,133719,443998,328330,13008,956839,180169,78401,767827,180376,824451,883313,834773,318240,293501,620038,963774,588992,973113,292336,582022,933890,481394,734782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 923790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 923790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001514s ]