SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531400 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531400 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798620,763132,834250,535628,391302,827107,61212,514851,200412,746046,929467,691301,919073,965901,219824,817998,540868,190612,1042461,542820,902180,130017,491961,649133,182100,774360,13591,387423,277347,461529,56017,567711,712186,771460,994566,822200,802160,980871,992684,354077,528932,41187,52451,792901,533716,315346,957654,555315,498783,602441,754827,142585,269608,364728,784676,373314,171115,537078,583740,732496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]