SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654880 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654880 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113699,24759,50427,811348,42261,539350,962940,684780,767950,10967,998638,787413,879864,1003944,948761,1033247,437984,746464,802455,940172,248448,484491,767197,835076,129536,92760,771981,252707,726879,936303,633737,120117,734396,928505,178454,492155,1043513,971262,115773,337854,201494,989766,519916,161027,345079,988043,505792,275763,257284,400494,581450,312423,90914,325603,839194,558223,411034,241279,769162,728546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]