SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511999 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511999 [ RunTime:0.004340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134839,283542,371317,268548,581770,1047245,276402,217120,79975,392109,694458,85594,38862,949976,169888,421717,64491,94993,693304,104290,308537,391435,399330,24343,946710,986750,702127,111974,20327,112556,633122,244090,858360,710122,220605,989124,598155,690430,413724,885276,512335,892243,1036029,986441,335214,516442,97020,13602,270789,285694,849343,375441,513488,680587,922601,599353,247026,424380,427731,350557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]