SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046207 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046207 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988171,501516,271969,415333,164951,283997,422262,398292,1020314,670388,338903,76183,609522,686194,886405,162215,15834,50273,330208,575649,451169,866412,632969,732275,989412,168322,768494,940824,937023,16593,178744,217501,1035897,370321,674758,185237,277015,879727,953509,313565,416315,372052,302616,202345,571443,485463,97180,870641,518806,759772,254166,122963,1006240,798549,895730,225921,88949,255773,688982,407749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]