SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503138 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503138 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591584,25152,736644,775551,277491,658473,586060,920692,689747,742028,586159,917210,209212,710473,201783,276863,730349,838875,201008,343809,557344,763457,919596,840880,753962,981228,10901,807570,655605,363686,1037732,467265,419430,992497,611441,938079,897678,704922,675412,871762,146003,569666,243764,1022632,460060,12726,581256,334326,564056,662307,634998,940180,240065,980221,644110,627315,731009,1387,135747,202930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]