SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503031 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503031 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795564,346391,780813,588569,1034269,245369,263448,880843,177815,277871,997329,501656,878913,251035,102814,441510,836714,738252,104313,896115,489922,821662,436081,911657,321876,168747,619842,874902,618393,59679,27004,426047,570428,956947,895104,771065,705759,33783,398035,482890,231337,83631,866619,857005,226002,139940,767503,855494,436218,945549,239295,145771,388823,302294,544245,287004,156237,349195,992549,61613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]