SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327847 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327847 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334090,1014091,705342,731814,858024,647851,140508,611258,951909,225830,894240,409487,349836,600711,395415,1038098,640441,858642,615862,670180,426287,752074,627752,344339,195984,271385,986479,439992,800814,469991,742540,674187,91243,59894,823176,829602,285911,355891,891767,793239,202443,446980,355189,888883,242176,232005,587940,89470,1017426,68752,963931,491528,392394,407141,163590,337763,268966,576227,662085,376903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]