SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108331 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108331 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100015,699460,395465,265495,210107,756703,891588,368270,1043517,740430,994416,921094,362275,892053,461314,688101,788749,498955,894645,166413,445250,896061,403721,168321,619204,271674,6373,991843,280551,590240,462914,10303,207993,302436,752508,1039956,162394,81252,682564,463478,936503,706060,919767,422245,298466,459837,165312,685500,780047,69192,482156,608839,1029606,1001711,77777,950938,932681,560441,182098,323745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]