SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503728 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503728 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5256,352419,568231,156872,270780,392179,865690,739983,957246,649150,604657,924603,854172,327352,537236,782856,618259,501052,453453,14616,949391,216935,18179,1034582,203287,917926,250540,451216,703907,356446,727903,794658,815110,562980,565596,682759,1009814,814888,605996,561179,205564,699358,63131,707012,427084,204680,962585,302209,482119,313698,906894,788953,763857,586413,429445,157043,337210,675907,634831,240734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]