SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591693 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591693 [ RunTime:0.004247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403476,447606,392948,138626,70052,583328,253970,602428,491594,352509,1026050,690068,465059,974930,929845,752625,965976,1023474,604656,961549,984411,680747,447319,272124,973914,344867,600630,807633,749309,330064,594753,1011758,752672,544921,322565,110313,357241,570086,361886,667378,792817,254626,1048524,805015,247227,551954,632092,1015473,221623,955159,108731,322529,992611,166233,738427,380465,410525,422078,1047700,269237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]